PROMPT *-*-*-*-*-*-*  iemp Table creation STARTS... *-*-*-*-*-*-*

DROP TABLE iemp;

CREATE TABLE iemp
AS
SELECT employee_id, first_name, hire_date, salary, department_id
FROM employees
WHERE department_id IN(10,90,60);

PROMPT *-*-*-*-*-*-*  iemp Table creation ENDS... *-*-*-*-*-*-*

PROMPT *-*-*-*-*-*-*  sal_hist_tb Table creation STARTS... *-*-*-*-*-*-*


DROP TABLE sal_hist_tb;

CREATE TABLE sal_hist_tb
(
  employee_id   NUMBER
, hike_pct      NUMBER
, old_sal       NUMBER
, new_sal       NUMBER
, sal_dif       NUMBER
, updated_by    VARCHAR2(10)
, updated_dttm  TIMESTAMP
, info_cng_num  NUMBER
);

PROMPT *-*-*-*-*-*-*  sal_hist_tb Table creation ENDS... *-*-*-*-*-*-*